MS Excel Question. 1
1. What is extension of files created in
MS-Excel 97-2003
(a) .xlx
(b) .msx
(c) .Dot
(d) .xls
2. What is extension of files created in
MS-Excel 2007-2015
(a) Txt
(b) XLS
(c) XLSX
(d) RTF
3. MS-Office is -
(a) Application Software
(b) System Software
(c) Operating System
(d) All of above
4. Which menu option in MS Excel has the
option to "Sort the Data"
(a) Review
(b) Data
(c) Formula
(d) Insert
5. Which is the correct formula for SUM
Function in MS Excel.
(a) /SUM(A1+A5)
(b) =SUM(A1-A5)
(c) =SUM(A1:A5)
(d) +SUM(A1:A5)
6. What is the use of VLOOKUP function in MS
Excel -
(a) to get the max value
(b) to copy a row
(c) to find things in a table
(d) None of these
7. Which button in MSExcel to calculate the
sum of number
(a) AutoSum
(b) Fill
(c) Insert
(d) Merge
8. What is the Shortcut key for "Current
Date" in Excel
(a) Ctrl + C
(b) Ctrl + D
(c) Alt + ;
(d) Ctrl + ;
9. What is the Shortcut key for "Current
Time" in Excel
(a) Ctrl + Shift + :
(b) Ctrl + T
(c) Ctrl + D
(d) Ctrl + ;
10. What is the shortcut to insert comment in
MS Excel
(a) Ctrl + F6
(b) Alt + F8
(c) Shift + F9
(d) Shift + F2
11. Which function in MS Excel counts the
number of characters in a Cell
(a) Len ( )
(b) Length ( )
(c) Count ( )
(d) LNG ( )
Answer – (d) Len ( )
12. What of these is a shortcut to add a
border to the selected cell in MS Excel
(a) Ctrl + T
(b) Ctrl + B
(c) Shift + B
(d) Ctrl + Shift + &
13. What is the shortcut key of Hyperlink in
Excel
(a) Ctrl + H
(b) Ctrl + K
(c) Alt + S
(d) Alt + K
14. What is the Shortcut key for select
Complete Row
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
15. What is the Shortcut key for select
Complete Column
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
16. What is the intersection of a column
and row on worksheet called ?
(a) Row
(b) Column
(c) Cell
(d) Address
17. MS Excel is a -
(a) Word Processing Software
(b) Spreadsheet Program
(c) Presentation Program
(d) None of these
18. The Software which contains rows and
column is called -
(a) Word Processing
(b) Database
(c) Spreadsheet
(d) None of these
19. Formulas in Excel Start with -
(a) +
(b) #
(c) %
(d) =
20. To return the remainder after a no. is
divided by a divisor in Excel
(a) Round ( )
(b) Mod ( )
(c) Fact ( )
(d) None of these
21. Hyperlinks can be
(a) Text
(b) Drawing
(c) Picture
(d) All of the above
22. NOT, AND, OR and XOR are -
(a) Relational Operator
(b) Logical Operators
(c) Arithmetic Operators
(d) None of these
23. The shortcut key to hide entire column
(a) Ctrl + H
(b) Ctrl + 0
(c) Ctrl + -
(d) None of these
24. Which of the following is correct -
(a) = power (2^3)
(b) = power (2*3)
(c) = power (2,3)
(d) None of these
25. What is the shortcut key to insert a new
comment in a cell ?
(a) ALT + F2
(b) Ctrl + F2
(c) Shift + F2
(d) None of these
26. What is the shortcut key to insert new
sheet in current workbook ?
(a) Shift + F11
(b) Ctrl + F11
(c) Atl + F11
(d) None of these
27. How many sheets are there, by default,
when we create a new excel file ?
(a) 1
(b) 2
(c) 3
(d) 4
28. Which sign display when formula error in
MS Excel
(a) $
(b) *
(c) #
(d) \
29. What is the Shortcut Key of
"AutoSum"
(a) Ctrl + =
(b) Alt + =
(c) Ctrl + A
(d) Shift + =
30. What is the Shortcut Key for Insert (Row,
Column)
(a) Ctrl + +
(b) Ctrl + C
(c) Ctrl + R
(d) Ctrl + A
31. What is the Shortcut Key for Delete (Row,
Column)
(a) Ctrl + D
(b) Ctrl + R
(c) Ctrl + C
(d) Ctrl + -
32. The Shortcut Key for Hide Rows
(a) Ctrl + 9
(b) Ctrl + S
(c) Ctrl + H
(d) Ctrl + R
33. The Shortcut Key for Hide Columns
(a) Ctrl + H
(b) Ctrl + C
(c) Ctrl + 9
(d) Ctrl + 0
34. The Shortcut Key for Unhide Rows
(a) Ctrl + Shift + (
(b) Ctrl + U
(c) Ctrl + H
(d) Ctrl + R
35. The Shortcut Key for Unhide Columns
(a) Ctrl + H
(b) Ctrl + K
(c) Ctrl + Shift + )
(d) Ctrl + Z
Post a Comment